Tabela AuthorisationData

Definicja tabeli AuthorisationData

Name

AuthorisationData

Code

AuthorisationData

Comment

 


Lista kolumn tabeli AuthorisationData

Name

Code

AuthorisationDataID

AuthorisationDataID

PersonID

PersonID

PIN

PIN

DateValue

DateValue


Kolumna AuthorisationDataID tabeli AuthorisationData

Definicja kolumny AuthorisationDataID tabeli AuthorisationData

Name

AuthorisationDataID

Code

AuthorisationDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli AuthorisationData

Definicja kolumny PersonID tabeli AuthorisationData

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PIN tabeli AuthorisationData

Definicja kolumny PIN tabeli AuthorisationData

Name

PIN

Code

PIN

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna DateValue tabeli AuthorisationData

Definicja kolumny DateValue tabeli AuthorisationData

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli AuthorisationData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli AuthorisationData

Definicja klucza Identifier_1 tabeli AuthorisationData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment